<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
 "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
	<title>database_view</title>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
	<meta name="date" content="Fri, 30 Apr 2010 02:23:37 +0800">
	<meta name="generator" content="MySQL-Front 5.1  (Build 1.20)">
	<style type="text/css"><!--
		body {font-family: Arial,Helvetica,sans-serif; font-size: 11px;}
		h1 {font-size: 17px; text-decoration: bold;}
		h2 {font-size: 15px; text-decoration: bold;}
		h3 {font-size: 13px; text-decoration: bold;}
		th {font-size: 11px; border-style: solid; border-width: 1px; text-decoration: bold; padding: 1px;}
		td {font-size: 11px; border-style: solid; border-width: 1px; padding: 1px;}
		code {font-size: 11px; white-space: pre;}
		.TableObject {border-collapse: collapse; border-color: #000000; font-family: Microsoft Sans Serif}
		.TableData {border-collapse: collapse; border-color: #000000; font-family: Microsoft Sans Serif}
		.TableHeader {border-color: #000000; text-decoration: bold; background-color: #e0e0e0;}
		.ObjectHeader {padding-left: 5px; text-align: left; border-color: #000000; text-decoration: bold;}
		.ObjectOfPrimaryKey {text-align: left; border-color: #aaaaaa; text-decoration: bold; background-color: #e0e0e0;}
		.ObjectOfUniqueKey {text-align: left; border-color: #aaaaaa; background-color: #e0e0e0;}
		.Object {text-align: left; border-color: #aaaaaa;}
		.Record_1 {}
		.Record_2 {}
		.DataHeader {padding-left: 5px; text-align: left; text-decoration: bold; border-color: #000000; background-color: #e0e0e0;}
		.DataOfPrimaryKey {text-align: left; text-decoration: bold; border-color: #aaaaaa; background-color: #e0e0e0;}
		.DataOfUniqueKey {border-color: #aaaaaa;}
		.Data {border-color: #aaaaaa;}
		.DataRightAlign {text-align: right;}
		.DataNull {color: #999999; border-color: #aaaaaa;}
	--></style>
</head>
<body>
<h1 class="DatabaseTitle">数据库: photo</h1>
<h2 class="TableTitle">表格: photo_admin</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="photo_admin" class="TableObject">
	<tr class="TableHeader"><th class="ObjectHeader">名称</th><th class="ObjectHeader">类型</th></tr>
	<tr class="TableHeader"><th  class="ObjectOfPrimaryKey">主索引</th><td class="ObjectOfPrimaryKey">id</td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="photo_admin" class="TableObject">
	<tr class="TableHeader"><th class="ObjectHeader">名称</th><th class="ObjectHeader">类型</th><th class="ObjectHeader">空</th><th class="ObjectHeader">默认值</th><th class="ObjectHeader">属性</th><th class="ObjectHeader">备注</th></tr>
	<tr><th class="ObjectOfPrimaryKey">id</th><td class="ObjectOfPrimaryKey">int(11) unsigned</td><td class="ObjectOfPrimaryKey">&nbsp;</td><td class="ObjectOfPrimaryKey">&nbsp;</td><td class="ObjectOfPrimaryKey">auto_increment</td><td class="ObjectOfPrimaryKey">&nbsp;</td>	</tr>
	<tr><th class="Object">username</th><td class="Object">char(20)</td><td class="Object">NULL</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">&nbsp;</td>	</tr>
	<tr><th class="Object">password</th><td class="Object">char(50)</td><td class="Object">NULL</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">&nbsp;</td>	</tr>
</table><br>
<h2 class="TableTitle">表格: photo_comment</h2>
<p>备注: 评论</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="photo_comment" class="TableObject">
	<tr class="TableHeader"><th class="ObjectHeader">名称</th><th class="ObjectHeader">类型</th></tr>
	<tr class="TableHeader"><th  class="ObjectOfPrimaryKey">主索引</th><td class="ObjectOfPrimaryKey">id</td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="photo_comment" class="TableObject">
	<tr class="TableHeader"><th class="ObjectHeader">名称</th><th class="ObjectHeader">类型</th><th class="ObjectHeader">空</th><th class="ObjectHeader">默认值</th><th class="ObjectHeader">属性</th><th class="ObjectHeader">备注</th></tr>
	<tr><th class="ObjectOfPrimaryKey">id</th><td class="ObjectOfPrimaryKey">int(11)</td><td class="ObjectOfPrimaryKey">&nbsp;</td><td class="ObjectOfPrimaryKey">&nbsp;</td><td class="ObjectOfPrimaryKey">auto_increment</td><td class="ObjectOfPrimaryKey">&nbsp;</td>	</tr>
	<tr><th class="Object">imageid</th><td class="Object">int(11)</td><td class="Object">NULL</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">作品id</td>	</tr>
	<tr><th class="Object">content</th><td class="Object">text</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">&nbsp;</td><td class="Object">评论</td>	</tr>
	<tr><th class="Object">createtime</th><td class="Object">int(11)</td><td class="Object">NULL</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">创建时间</td>	</tr>
</table><br>
<h2 class="TableTitle">表格: photo_image</h2>
<p>备注: 摄影作品</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="photo_image" class="TableObject">
	<tr class="TableHeader"><th class="ObjectHeader">名称</th><th class="ObjectHeader">类型</th></tr>
	<tr class="TableHeader"><th  class="ObjectOfPrimaryKey">主索引</th><td class="ObjectOfPrimaryKey">id</td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="photo_image" class="TableObject">
	<tr class="TableHeader"><th class="ObjectHeader">名称</th><th class="ObjectHeader">类型</th><th class="ObjectHeader">空</th><th class="ObjectHeader">默认值</th><th class="ObjectHeader">属性</th><th class="ObjectHeader">备注</th></tr>
	<tr><th class="ObjectOfPrimaryKey">id</th><td class="ObjectOfPrimaryKey">int(11)</td><td class="ObjectOfPrimaryKey">&nbsp;</td><td class="ObjectOfPrimaryKey">&nbsp;</td><td class="ObjectOfPrimaryKey">auto_increment</td><td class="ObjectOfPrimaryKey">&nbsp;</td>	</tr>
	<tr><th class="Object">title</th><td class="Object">varchar(200)</td><td class="Object">NULL</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">标题</td>	</tr>
	<tr><th class="Object">author</th><td class="Object">varchar(255)</td><td class="Object">NULL</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">作者</td>	</tr>
	<tr><th class="Object">phone</th><td class="Object">varchar(255)</td><td class="Object">NULL</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">电话</td>	</tr>
	<tr><th class="Object">content</th><td class="Object">text</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">&nbsp;</td><td class="Object">内容</td>	</tr>
	<tr><th class="Object">description</th><td class="Object">text</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">&nbsp;</td><td class="Object">描述</td>	</tr>
	<tr><th class="Object">createtime</th><td class="Object">varchar(255)</td><td class="Object">NULL</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">创建时间</td>	</tr>
	<tr><th class="Object">imageurl</th><td class="Object">varchar(255)</td><td class="Object">NULL</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">图片路径</td>	</tr>
	<tr><th class="Object">votenum</th><td class="Object">int(11)</td><td class="Object">NULL</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">投票数量</td>	</tr>
</table><br>
<h2 class="TableTitle">表格: photo_news</h2>
<p>备注: 公告</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="photo_news" class="TableObject">
	<tr class="TableHeader"><th class="ObjectHeader">名称</th><th class="ObjectHeader">类型</th></tr>
	<tr class="TableHeader"><th  class="ObjectOfPrimaryKey">主索引</th><td class="ObjectOfPrimaryKey">id</td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="photo_news" class="TableObject">
	<tr class="TableHeader"><th class="ObjectHeader">名称</th><th class="ObjectHeader">类型</th><th class="ObjectHeader">空</th><th class="ObjectHeader">默认值</th><th class="ObjectHeader">属性</th><th class="ObjectHeader">备注</th></tr>
	<tr><th class="ObjectOfPrimaryKey">id</th><td class="ObjectOfPrimaryKey">int(11) unsigned</td><td class="ObjectOfPrimaryKey">&nbsp;</td><td class="ObjectOfPrimaryKey">&nbsp;</td><td class="ObjectOfPrimaryKey">auto_increment</td><td class="ObjectOfPrimaryKey">&nbsp;</td>	</tr>
	<tr><th class="Object">content</th><td class="Object">text</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">&nbsp;</td><td class="Object">内容</td>	</tr>
	<tr><th class="Object">createtime</th><td class="Object">int(11)</td><td class="Object">NULL</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">创建时间</td>	</tr>
	<tr><th class="Object">posttime</th><td class="Object">int(11)</td><td class="Object">NULL</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">发布时间</td>	</tr>
	<tr><th class="Object">title</th><td class="Object">char(200)</td><td class="Object">NULL</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">标题</td>	</tr>
</table><br>
<h2 class="TableTitle">表格: photo_vote</h2>
<p>备注: 投票记录</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="photo_vote" class="TableObject">
	<tr class="TableHeader"><th class="ObjectHeader">名称</th><th class="ObjectHeader">类型</th></tr>
	<tr class="TableHeader"><th  class="ObjectOfPrimaryKey">主索引</th><td class="ObjectOfPrimaryKey">ip</td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="photo_vote" class="TableObject">
	<tr class="TableHeader"><th class="ObjectHeader">名称</th><th class="ObjectHeader">类型</th><th class="ObjectHeader">空</th><th class="ObjectHeader">默认值</th><th class="ObjectHeader">属性</th><th class="ObjectHeader">备注</th></tr>
	<tr><th class="ObjectOfPrimaryKey">ip</th><td class="ObjectOfPrimaryKey">int(11)</td><td class="ObjectOfPrimaryKey">&nbsp;</td><td class="ObjectOfPrimaryKey">&nbsp;</td><td class="ObjectOfPrimaryKey">auto_increment</td><td class="ObjectOfPrimaryKey">ip地址</td>	</tr>
	<tr><th class="Object">votetime</th><td class="Object">varchar(20)</td><td class="Object">NULL</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">投票时间</td>	</tr>
	<tr><th class="Object">imageid</th><td class="Object">varchar(255)</td><td class="Object">NULL</td><td class="Object">NULL</td><td class="Object">&nbsp;</td><td class="Object">作品ID</td>	</tr>
</table><br>
</body>
</html>
